Re: UNICODE and SQL - Mailing list pgsql-sql

From Ian Barwick
Subject Re: UNICODE and SQL
Date
Msg-id 200305051637.19406.Ian Barwick <>
Whole thread Raw
In response to UNICODE and SQL  ("Marco Roda" <MarcoRoda@amdosoft.com>)
List pgsql-sql
On Monday 05 May 2003 15:34, Marco Roda wrote:
> Hallo,
>
> I need to use SQL to insert some language specific characters into tables.
> In particular I am using German and Croatian specific characters. The
> database is created with UNICODE encoding.
> For instance, when trying to run from psql:
>
> INSERT INTO test VALUES (1,'Urlaubslite für nächstes Jahr');
>
> I get the following error:
>
> ERROR:  Invalid UNICODE character sequence found (0xfc7220)
>
> because of 'ü' and 'ä'.

What is your psql client encoding set to? Possibly you need
to set it to LATIN1.

Ian Barwick
barwick@gmx.net



pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: UNICODE and SQL
Next
From: Achilleus Mantzios
Date:
Subject: Re: UNICODE and SQL